Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$SYSTEM_PARAMETER

`V$SYSTEM_PARAMETER` displays information about the initialization parameters that are currently in effect for the instance. A new session inherits parameter values from the instance-wide values.

Column | Datatype | Description
--- | --- | ---
`NUM` | `NUMBER` | Parameter number
`NAME` | `VARCHAR2(80)` | Name of the parameter
`TYPE` | `NUMBER` | Parameter type: `1` - Boolean `2` - String `3` - Integer `4` - Parameter file `5` - Reserved `6` - Big integer
`VALUE` | `VARCHAR2(512)` | Instance-wide parameter value
`DISPLAY_VALUE` | `VARCHAR2(512)` | Parameter value in a user-friendly format. For example, if the `VALUE` column shows the value `262144` for a big integer parameter, then the `DISPLAY_VALUE` column will show the value `256K`.
`ISDEFAULT` | `VARCHAR2(9)` | Indicates whether the parameter is set to the default value (`TRUE`) or the parameter value was specified in the parameter file (`FALSE`)
`ISSES_MODIFIABLE` | `VARCHAR2(5)` | Indicates whether the parameter can be changed with `ALTER SESSION` (`TRUE`) or not (`FALSE`)
`ISSYS_MODIFIABLE` | `VARCHAR2(9)` | Indicates whether the parameter can be changed with `ALTER SYSTEM` and when the change takes effect: `IMMEDIATE` - Parameter can be changed with `ALTER SYSTEM` regardless of the type of parameter file used to start the instance. The change takes effect immediately. `DEFERRED` - Parameter can be changed with `ALTER SYSTEM` regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions. `FALSE` - Parameter cannot be changed with `ALTER SYSTEM` unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.
`ISINSTANCE_MODIFIABLE` | `VARCHAR2(5)` | For parameters that can be changed with `ALTER SYSTEm`, indicates whether the value of the parameter can be different for every instance (`TRUE`) or whether the parameter must have the same value for all Real Application Clusters instances (`FALSE`). If the `ISSYS_MODIFIABLE` column is `FALSE`, then this column is always `FALSE`.
`ISMODIFIED` | `VARCHAR2(8)` | Indicates how the parameter was modified. If an `ALTER SYSTEM` was performed, the value will be `MODIFIED`.
`ISADJUSTED` | `VARCHAR2(5)` | Indicates whether Oracle adjusted the input value to a more suitable value (for example, the parameter value should be prime, but the user input a non-prime number, so Oracle adjusted the value to the next prime number)
`ISDEPRECATED` | `VARCHAR2(5)` | Indicates whether the parameter has been deprecated (`TRUE`) or not (`FALSE`)
`DESCRIPTION` | `VARCHAR2(255)` | Description of the parameter
`UPDATE_COMMENT` | `VARCHAR2(255)` | Comments associated with the most recent update
`HASH` | `NUMBER` | Hash value for the parameter name